package com.mairuide.bill.titlepool;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.mairuide._frame.base.BaseRepository;

/**
 * @author: zyh
 * @description:
 * @date: 2018/11/13 0013
 * @company: MRD
 */
@Repository
public interface DealFlowTitlePoolRepository extends BaseRepository<DealFlowTitlePool> {
    //根据标题名查询一条标题信息
    DealFlowTitlePool findByBankTitleName(String ss);
    List<DealFlowTitlePool> findByBankTitleNameAndClassNameOrderById(String bankTitleName,String className);
    //根据标题父级id和创建者id获取标题集合
    List<DealFlowTitlePool> findByTitleIdAndCreateIdAndIsDelete(Integer titleId,Integer greatId,Integer isdelete);
    List<DealFlowTitlePool> findByTitleIdAndIsDelete(Integer titleId,Integer isdelete);
    //根据标题名模糊查询,
    //@Query(value = "select * from tb_deal_flow_title_pool  where bank_title_name like '%?0%'" ,nativeQuery = true )
    List<DealFlowTitlePool> findByBankTitleNameLike(String bankTitleName);

}
